Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 160 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 16.2 KiB |
| Average record size in memory | 104.0 B |
Variable types
| Text | 2 |
|---|---|
| Numeric | 9 |
| Categorical | 1 |
All Grades is highly overall correlated with Total Students and 4 other fields | High correlation |
Total Students is highly overall correlated with All Grades and 3 other fields | High correlation |
AfriAmerican-Black-% is highly overall correlated with All Grades and 1 other fields | High correlation |
Secondary is highly overall correlated with Primary | High correlation |
High is highly overall correlated with All Grades and 4 other fields | High correlation |
Tests Taken is highly overall correlated with All Grades and 5 other fields | High correlation |
% Score 1-2 is highly overall correlated with Tests Taken and 1 other fields | High correlation |
% Score 3-5 is highly overall correlated with Tests Taken and 1 other fields | High correlation |
Primary is highly overall correlated with All Grades and 4 other fields | High correlation |
Primary is highly imbalanced (90.6%) | Imbalance |
District Name_x has unique values | Unique |
District Code has unique values | Unique |
District Name_y has unique values | Unique |
All Grades has 25 (15.6%) zeros | Zeros |
AfriAmerican-Black-% has 25 (15.6%) zeros | Zeros |
Secondary has 130 (81.2%) zeros | Zeros |
High has 25 (15.6%) zeros | Zeros |
% Score 1-2 has 141 (88.1%) zeros | Zeros |
% Score 3-5 has 145 (90.6%) zeros | Zeros |
Reproduction
| Analysis started | 2023-07-02 22:20:20.983118 |
|---|---|
| Analysis finished | 2023-07-02 22:20:26.611254 |
| Duration | 5.63 seconds |
| Software version | ydata-profiling vv4.3.1 |
| Download configuration | config.json |
District Name_x
Text
UNIQUE
| Distinct | 160 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.5 KiB |
Length
| Max length | 77 |
|---|---|
| Median length | 57 |
| Mean length | 17.53125 |
| Min length | 4 |
Characters and Unicode
| Total characters | 2805 |
|---|---|
| Distinct characters | 53 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 160 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | Abington |
|---|---|
| 2nd row | Academy Of the Pacific Rim Charter Public (District) |
| 3rd row | Advanced Math and Science Academy Charter (District) |
| 4th row | Amherst-Pelham |
| 5th row | Andover |
| Value | Count | Frequency (%) |
| district | 27 | 7.9% |
| charter | 24 | 7.0% |
| regional | 15 | 4.4% |
| vocational | 12 | 3.5% |
| school | 12 | 3.5% |
| technical | 11 | 3.2% |
| academy | 9 | 2.6% |
| public | 6 | 1.8% |
| of | 6 | 1.8% |
| science | 4 | 1.2% |
| Other values (182) | 215 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 230 | 8.2% |
| o | 210 | 7.5% |
| t | 206 | 7.3% |
| a | 203 | 7.2% |
| r | 198 | 7.1% |
| 181 | 6.5% | |
| i | 176 | 6.3% |
| n | 159 | 5.7% |
| l | 151 | 5.4% |
| c | 120 | 4.3% |
| Other values (43) | 971 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2199 | |
| Uppercase Letter | 357 | 12.7% |
| Space Separator | 181 | 6.5% |
| Close Punctuation | 26 | 0.9% |
| Open Punctuation | 26 | 0.9% |
| Dash Punctuation | 14 | 0.5% |
| Other Punctuation | 2 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 230 | |
| o | 210 | |
| t | 206 | |
| a | 203 | |
| r | 198 | |
| i | 176 | 8.0% |
| n | 159 | 7.2% |
| l | 151 | 6.9% |
| c | 120 | 5.5% |
| h | 105 | 4.8% |
| Other values (14) | 441 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 44 | |
| S | 40 | |
| D | 33 | 9.2% |
| R | 25 | 7.0% |
| A | 24 | 6.7% |
| M | 22 | 6.2% |
| B | 22 | 6.2% |
| P | 21 | 5.9% |
| W | 19 | 5.3% |
| T | 18 | 5.0% |
| Other values (13) | 89 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 1 | |
| . | 1 |
Space Separator
| Value | Count | Frequency (%) |
| 181 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 26 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 26 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 14 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2556 | |
| Common | 249 | 8.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 230 | 9.0% |
| o | 210 | 8.2% |
| t | 206 | 8.1% |
| a | 203 | 7.9% |
| r | 198 | 7.7% |
| i | 176 | 6.9% |
| n | 159 | 6.2% |
| l | 151 | 5.9% |
| c | 120 | 4.7% |
| h | 105 | 4.1% |
| Other values (37) | 798 |
Common
| Value | Count | Frequency (%) |
| 181 | ||
| ) | 26 | 10.4% |
| ( | 26 | 10.4% |
| - | 14 | 5.6% |
| ' | 1 | 0.4% |
| . | 1 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2805 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 230 | 8.2% |
| o | 210 | 7.5% |
| t | 206 | 7.3% |
| a | 203 | 7.2% |
| r | 198 | 7.1% |
| 181 | 6.5% | |
| i | 176 | 6.3% |
| n | 159 | 5.7% |
| l | 151 | 5.4% |
| c | 120 | 4.3% |
| Other values (43) | 971 |
District Code
Real number (ℝ)
UNIQUE
| Distinct | 160 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3724937.5 |
| Minimum | 0 |
|---|---|
| Maximum | 35060000 |
| Zeros | 1 |
| Zeros (%) | 0.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 199000 |
| Q1 | 1242500 |
| median | 2725000 |
| Q3 | 4872500 |
| 95-th percentile | 8311500 |
| Maximum | 35060000 |
| Range | 35060000 |
| Interquartile range (IQR) | 3630000 |
Descriptive statistics
| Standard deviation | 4387719 |
|---|---|
| Coefficient of variation (CV) | 1.1779309 |
| Kurtosis | 31.111705 |
| Mean | 3724937.5 |
| Median Absolute Deviation (MAD) | 1745000 |
| Skewness | 4.6844827 |
| Sum | 5.9599 × 108 |
| Variance | 1.9252078 × 1013 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10000 | 1 | 0.6% |
| 4120000 | 1 | 0.6% |
| 2070000 | 1 | 0.6% |
| 2110000 | 1 | 0.6% |
| 2120000 | 1 | 0.6% |
| 7300000 | 1 | 0.6% |
| 8530000 | 1 | 0.6% |
| 2200000 | 1 | 0.6% |
| 2260000 | 1 | 0.6% |
| 2290000 | 1 | 0.6% |
| Other values (150) | 150 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 10000 | 1 | |
| 90000 | 1 | |
| 100000 | 1 | |
| 140000 | 1 | |
| 160000 | 1 | |
| 170000 | 1 | |
| 180000 | 1 | |
| 200000 | 1 | |
| 250000 | 1 |
| Value | Count | Frequency (%) |
| 35060000 | 1 | |
| 35030000 | 1 | |
| 9100000 | 1 | |
| 8850000 | 1 | |
| 8760000 | 1 | |
| 8730000 | 1 | |
| 8720000 | 1 | |
| 8530000 | 1 | |
| 8300000 | 1 | |
| 8280000 | 1 |
All Grades
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 42 |
|---|---|
| Distinct (%) | 26.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 33.60625 |
| Minimum | 0 |
|---|---|
| Maximum | 2843 |
| Zeros | 25 |
| Zeros (%) | 15.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 5 |
| Q3 | 14.25 |
| 95-th percentile | 60.05 |
| Maximum | 2843 |
| Range | 2843 |
| Interquartile range (IQR) | 13.25 |
Descriptive statistics
| Standard deviation | 227.52975 |
|---|---|
| Coefficient of variation (CV) | 6.7704594 |
| Kurtosis | 148.83378 |
| Mean | 33.60625 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 12.03277 |
| Sum | 5377 |
| Variance | 51769.787 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=42)
| Value | Count | Frequency (%) |
| 0 | 25 | |
| 2 | 21 | 13.1% |
| 1 | 16 | 10.0% |
| 4 | 11 | 6.9% |
| 6 | 8 | 5.0% |
| 9 | 6 | 3.8% |
| 3 | 5 | 3.1% |
| 8 | 5 | 3.1% |
| 7 | 5 | 3.1% |
| 5 | 4 | 2.5% |
| Other values (32) | 54 |
| Value | Count | Frequency (%) |
| 0 | 25 | |
| 1 | 16 | |
| 2 | 21 | |
| 3 | 5 | 3.1% |
| 4 | 11 | |
| 5 | 4 | 2.5% |
| 6 | 8 | 5.0% |
| 7 | 5 | 3.1% |
| 8 | 5 | 3.1% |
| 9 | 6 | 3.8% |
| Value | Count | Frequency (%) |
| 2843 | 1 | 0.6% |
| 464 | 1 | 0.6% |
| 157 | 1 | 0.6% |
| 141 | 1 | 0.6% |
| 120 | 1 | 0.6% |
| 105 | 1 | 0.6% |
| 69 | 1 | 0.6% |
| 61 | 1 | 0.6% |
| 60 | 1 | 0.6% |
| 52 | 3 |
Total Students
Real number (ℝ)
HIGH CORRELATION
| Distinct | 137 |
|---|---|
| Distinct (%) | 85.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 959.8375 |
| Minimum | 10 |
|---|---|
| Maximum | 82946 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 KiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 20.95 |
| Q1 | 58 |
| median | 160 |
| Q3 | 368.5 |
| 95-th percentile | 1288.9 |
| Maximum | 82946 |
| Range | 82936 |
| Interquartile range (IQR) | 310.5 |
Descriptive statistics
| Standard deviation | 6651.0269 |
|---|---|
| Coefficient of variation (CV) | 6.9293259 |
| Kurtosis | 147.82087 |
| Mean | 959.8375 |
| Median Absolute Deviation (MAD) | 115.5 |
| Skewness | 11.975573 |
| Sum | 153574 |
| Variance | 44236159 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 39 | 5 | 3.1% |
| 21 | 3 | 1.9% |
| 104 | 3 | 1.9% |
| 72 | 3 | 1.9% |
| 58 | 2 | 1.2% |
| 57 | 2 | 1.2% |
| 136 | 2 | 1.2% |
| 252 | 2 | 1.2% |
| 14 | 2 | 1.2% |
| 23 | 2 | 1.2% |
| Other values (127) | 134 |
| Value | Count | Frequency (%) |
| 10 | 1 | 0.6% |
| 13 | 1 | 0.6% |
| 14 | 2 | |
| 16 | 1 | 0.6% |
| 19 | 1 | 0.6% |
| 20 | 2 | |
| 21 | 3 | |
| 23 | 2 | |
| 25 | 1 | 0.6% |
| 26 | 1 | 0.6% |
| Value | Count | Frequency (%) |
| 82946 | 1 | |
| 12761 | 1 | |
| 8936 | 1 | |
| 4024 | 1 | |
| 3841 | 1 | |
| 1695 | 1 | |
| 1622 | 1 | |
| 1401 | 1 | |
| 1283 | 1 | |
| 1199 | 1 |
AfriAmerican-Black-%
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 128 |
|---|---|
| Distinct (%) | 80.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.2813751 |
| Minimum | 0 |
|---|---|
| Maximum | 47.619048 |
| Zeros | 25 |
| Zeros (%) | 15.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1.0725909 |
| median | 2.9948131 |
| Q3 | 6.4059391 |
| 95-th percentile | 18.937885 |
| Maximum | 47.619048 |
| Range | 47.619048 |
| Interquartile range (IQR) | 5.3333482 |
Descriptive statistics
| Standard deviation | 6.898282 |
|---|---|
| Coefficient of variation (CV) | 1.3061526 |
| Kurtosis | 10.724068 |
| Mean | 5.2813751 |
| Median Absolute Deviation (MAD) | 2.1750859 |
| Skewness | 2.7653427 |
| Sum | 845.02001 |
| Variance | 47.586295 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 25 | 15.6% |
| 3.703703704 | 3 | 1.9% |
| 10 | 2 | 1.2% |
| 2.127659574 | 2 | 1.2% |
| 1.388888889 | 2 | 1.2% |
| 13.79310345 | 2 | 1.2% |
| 5.357142857 | 2 | 1.2% |
| 1.941747573 | 2 | 1.2% |
| 4.8 | 1 | 0.6% |
| 1.398601399 | 1 | 0.6% |
| Other values (118) | 118 |
| Value | Count | Frequency (%) |
| 0 | 25 | |
| 0.380952381 | 1 | 0.6% |
| 0.4016064257 | 1 | 0.6% |
| 0.4170141785 | 1 | 0.6% |
| 0.6211180124 | 1 | 0.6% |
| 0.7518796992 | 1 | 0.6% |
| 0.8130081301 | 1 | 0.6% |
| 0.826446281 | 1 | 0.6% |
| 0.8333333333 | 1 | 0.6% |
| 0.8438818565 | 1 | 0.6% |
| Value | Count | Frequency (%) |
| 47.61904762 | 1 | |
| 35 | 1 | |
| 26.85185185 | 1 | |
| 25.67567568 | 1 | |
| 22.22222222 | 1 | |
| 20 | 1 | |
| 19.80676329 | 1 | |
| 19.29824561 | 1 | |
| 18.91891892 | 1 | |
| 17.85714286 | 1 |
Primary
Categorical
HIGH CORRELATION IMBALANCE
| Distinct | 5 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.5 KiB |
| 0.0 | |
|---|---|
| 13.0 | 1 |
| 6.0 | 1 |
| 4.0 | 1 |
| 33.0 | 1 |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.0125 |
| Min length | 3 |
Characters and Unicode
| Total characters | 482 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | 2.5% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 156 | |
| 13.0 | 1 | 0.6% |
| 6.0 | 1 | 0.6% |
| 4.0 | 1 | 0.6% |
| 33.0 | 1 | 0.6% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 156 | |
| 13.0 | 1 | 0.6% |
| 6.0 | 1 | 0.6% |
| 4.0 | 1 | 0.6% |
| 33.0 | 1 | 0.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 316 | |
| . | 160 | |
| 3 | 3 | 0.6% |
| 1 | 1 | 0.2% |
| 6 | 1 | 0.2% |
| 4 | 1 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 322 | |
| Other Punctuation | 160 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 316 | |
| 3 | 3 | 0.9% |
| 1 | 1 | 0.3% |
| 6 | 1 | 0.3% |
| 4 | 1 | 0.3% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 160 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 482 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 316 | |
| . | 160 | |
| 3 | 3 | 0.6% |
| 1 | 1 | 0.2% |
| 6 | 1 | 0.2% |
| 4 | 1 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 482 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 316 | |
| . | 160 | |
| 3 | 3 | 0.6% |
| 1 | 1 | 0.2% |
| 6 | 1 | 0.2% |
| 4 | 1 | 0.2% |
Secondary
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 18 |
|---|---|
| Distinct (%) | 11.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.86875 |
| Minimum | 0 |
|---|---|
| Maximum | 527 |
| Zeros | 130 |
| Zeros (%) | 81.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 16.1 |
| Maximum | 527 |
| Range | 527 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 42.600989 |
|---|---|
| Coefficient of variation (CV) | 7.2589545 |
| Kurtosis | 143.34406 |
| Mean | 5.86875 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.729272 |
| Sum | 939 |
| Variance | 1814.8443 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=18)
| Value | Count | Frequency (%) |
| 0 | 130 | |
| 1 | 5 | 3.1% |
| 3 | 4 | 2.5% |
| 15 | 3 | 1.9% |
| 6 | 3 | 1.9% |
| 13 | 2 | 1.2% |
| 29 | 2 | 1.2% |
| 16 | 1 | 0.6% |
| 45 | 1 | 0.6% |
| 5 | 1 | 0.6% |
| Other values (8) | 8 | 5.0% |
| Value | Count | Frequency (%) |
| 0 | 130 | |
| 1 | 5 | 3.1% |
| 2 | 1 | 0.6% |
| 3 | 4 | 2.5% |
| 5 | 1 | 0.6% |
| 6 | 3 | 1.9% |
| 7 | 1 | 0.6% |
| 11 | 1 | 0.6% |
| 13 | 2 | 1.2% |
| 15 | 3 | 1.9% |
| Value | Count | Frequency (%) |
| 527 | 1 | 0.6% |
| 98 | 1 | 0.6% |
| 45 | 1 | 0.6% |
| 29 | 2 | |
| 27 | 1 | 0.6% |
| 19 | 1 | 0.6% |
| 18 | 1 | 0.6% |
| 16 | 1 | 0.6% |
| 15 | 3 | |
| 13 | 2 |
High
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 36 |
|---|---|
| Distinct (%) | 22.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.3875 |
| Minimum | 0 |
|---|---|
| Maximum | 2283 |
| Zeros | 25 |
| Zeros (%) | 15.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 4 |
| Q3 | 10.25 |
| 95-th percentile | 52.4 |
| Maximum | 2283 |
| Range | 2283 |
| Interquartile range (IQR) | 9.25 |
Descriptive statistics
| Standard deviation | 184.05987 |
|---|---|
| Coefficient of variation (CV) | 6.7205796 |
| Kurtosis | 144.44984 |
| Mean | 27.3875 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 11.806348 |
| Sum | 4382 |
| Variance | 33878.038 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=36)
| Value | Count | Frequency (%) |
| 0 | 25 | |
| 1 | 24 | |
| 2 | 19 | |
| 3 | 10 | 6.2% |
| 6 | 10 | 6.2% |
| 4 | 9 | 5.6% |
| 8 | 7 | 4.4% |
| 5 | 6 | 3.8% |
| 7 | 5 | 3.1% |
| 9 | 4 | 2.5% |
| Other values (26) | 41 |
| Value | Count | Frequency (%) |
| 0 | 25 | |
| 1 | 24 | |
| 2 | 19 | |
| 3 | 10 | 6.2% |
| 4 | 9 | 5.6% |
| 5 | 6 | 3.8% |
| 6 | 10 | 6.2% |
| 7 | 5 | 3.1% |
| 8 | 7 | 4.4% |
| 9 | 4 | 2.5% |
| Value | Count | Frequency (%) |
| 2283 | 1 | 0.6% |
| 461 | 1 | 0.6% |
| 157 | 1 | 0.6% |
| 126 | 1 | 0.6% |
| 75 | 1 | 0.6% |
| 69 | 1 | 0.6% |
| 61 | 1 | 0.6% |
| 60 | 1 | 0.6% |
| 52 | 3 | |
| 41 | 1 | 0.6% |
District Name_y
Text
UNIQUE
| Distinct | 160 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.5 KiB |
Length
| Max length | 77 |
|---|---|
| Median length | 57 |
| Mean length | 17.53125 |
| Min length | 4 |
Characters and Unicode
| Total characters | 2805 |
|---|---|
| Distinct characters | 53 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 160 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | Abington |
|---|---|
| 2nd row | Academy Of the Pacific Rim Charter Public (District) |
| 3rd row | Advanced Math and Science Academy Charter (District) |
| 4th row | Amherst-Pelham |
| 5th row | Andover |
| Value | Count | Frequency (%) |
| district | 27 | 7.9% |
| charter | 24 | 7.0% |
| regional | 15 | 4.4% |
| vocational | 12 | 3.5% |
| school | 12 | 3.5% |
| technical | 11 | 3.2% |
| academy | 9 | 2.6% |
| public | 6 | 1.8% |
| of | 6 | 1.8% |
| science | 4 | 1.2% |
| Other values (182) | 215 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 230 | 8.2% |
| o | 210 | 7.5% |
| t | 206 | 7.3% |
| a | 203 | 7.2% |
| r | 198 | 7.1% |
| 181 | 6.5% | |
| i | 176 | 6.3% |
| n | 159 | 5.7% |
| l | 151 | 5.4% |
| c | 120 | 4.3% |
| Other values (43) | 971 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2199 | |
| Uppercase Letter | 357 | 12.7% |
| Space Separator | 181 | 6.5% |
| Close Punctuation | 26 | 0.9% |
| Open Punctuation | 26 | 0.9% |
| Dash Punctuation | 14 | 0.5% |
| Other Punctuation | 2 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 230 | |
| o | 210 | |
| t | 206 | |
| a | 203 | |
| r | 198 | |
| i | 176 | 8.0% |
| n | 159 | 7.2% |
| l | 151 | 6.9% |
| c | 120 | 5.5% |
| h | 105 | 4.8% |
| Other values (14) | 441 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 44 | |
| S | 40 | |
| D | 33 | 9.2% |
| R | 25 | 7.0% |
| A | 24 | 6.7% |
| M | 22 | 6.2% |
| B | 22 | 6.2% |
| P | 21 | 5.9% |
| W | 19 | 5.3% |
| T | 18 | 5.0% |
| Other values (13) | 89 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 1 | |
| . | 1 |
Space Separator
| Value | Count | Frequency (%) |
| 181 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 26 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 26 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 14 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2556 | |
| Common | 249 | 8.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 230 | 9.0% |
| o | 210 | 8.2% |
| t | 206 | 8.1% |
| a | 203 | 7.9% |
| r | 198 | 7.7% |
| i | 176 | 6.9% |
| n | 159 | 6.2% |
| l | 151 | 5.9% |
| c | 120 | 4.7% |
| h | 105 | 4.1% |
| Other values (37) | 798 |
Common
| Value | Count | Frequency (%) |
| 181 | ||
| ) | 26 | 10.4% |
| ( | 26 | 10.4% |
| - | 14 | 5.6% |
| ' | 1 | 0.4% |
| . | 1 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2805 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 230 | 8.2% |
| o | 210 | 7.5% |
| t | 206 | 7.3% |
| a | 203 | 7.2% |
| r | 198 | 7.1% |
| 181 | 6.5% | |
| i | 176 | 6.3% |
| n | 159 | 5.7% |
| l | 151 | 5.4% |
| c | 120 | 4.3% |
| Other values (43) | 971 |
Tests Taken
Real number (ℝ)
HIGH CORRELATION
| Distinct | 23 |
|---|---|
| Distinct (%) | 14.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.25 |
| Minimum | 1 |
|---|---|
| Maximum | 1140 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 5 |
| 95-th percentile | 25.4 |
| Maximum | 1140 |
| Range | 1139 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 92.490829 |
|---|---|
| Coefficient of variation (CV) | 6.4905845 |
| Kurtosis | 140.59757 |
| Mean | 14.25 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 11.604701 |
| Sum | 2280 |
| Variance | 8554.5535 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=23)
| Value | Count | Frequency (%) |
| 1 | 57 | |
| 2 | 28 | |
| 3 | 16 | 10.0% |
| 4 | 16 | 10.0% |
| 5 | 7 | 4.4% |
| 8 | 6 | 3.8% |
| 6 | 5 | 3.1% |
| 13 | 4 | 2.5% |
| 10 | 3 | 1.9% |
| 9 | 3 | 1.9% |
| Other values (13) | 15 | 9.4% |
| Value | Count | Frequency (%) |
| 1 | 57 | |
| 2 | 28 | |
| 3 | 16 | 10.0% |
| 4 | 16 | 10.0% |
| 5 | 7 | 4.4% |
| 6 | 5 | 3.1% |
| 7 | 3 | 1.9% |
| 8 | 6 | 3.8% |
| 9 | 3 | 1.9% |
| 10 | 3 | 1.9% |
| Value | Count | Frequency (%) |
| 1140 | 1 | |
| 257 | 1 | |
| 94 | 1 | |
| 72 | 1 | |
| 71 | 1 | |
| 40 | 1 | |
| 36 | 1 | |
| 33 | 1 | |
| 25 | 1 | |
| 18 | 1 |
% Score 1-2
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 17 |
|---|---|
| Distinct (%) | 10.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.230625 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 141 |
| Zeros (%) | 88.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 82.54 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 26.015796 |
|---|---|
| Coefficient of variation (CV) | 2.8184219 |
| Kurtosis | 5.3481007 |
| Mean | 9.230625 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.6265182 |
| Sum | 1476.9 |
| Variance | 676.82163 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=17)
| Value | Count | Frequency (%) |
| 0 | 141 | |
| 100 | 4 | 2.5% |
| 50 | 1 | 0.6% |
| 70.8 | 1 | 0.6% |
| 83.3 | 1 | 0.6% |
| 84.6 | 1 | 0.6% |
| 98.6 | 1 | 0.6% |
| 90 | 1 | 0.6% |
| 82.5 | 1 | 0.6% |
| 80 | 1 | 0.6% |
| Other values (7) | 7 | 4.4% |
| Value | Count | Frequency (%) |
| 0 | 141 | |
| 38.9 | 1 | 0.6% |
| 48 | 1 | 0.6% |
| 50 | 1 | 0.6% |
| 60 | 1 | 0.6% |
| 63.8 | 1 | 0.6% |
| 70.6 | 1 | 0.6% |
| 70.8 | 1 | 0.6% |
| 77 | 1 | 0.6% |
| 78.8 | 1 | 0.6% |
| Value | Count | Frequency (%) |
| 100 | 4 | |
| 98.6 | 1 | 0.6% |
| 90 | 1 | 0.6% |
| 84.6 | 1 | 0.6% |
| 83.3 | 1 | 0.6% |
| 82.5 | 1 | 0.6% |
| 80 | 1 | 0.6% |
| 78.8 | 1 | 0.6% |
| 77 | 1 | 0.6% |
| 70.8 | 1 | 0.6% |
% Score 3-5
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 16 |
|---|---|
| Distinct (%) | 10.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.644375 |
| Minimum | 0 |
|---|---|
| Maximum | 61.1 |
| Zeros | 145 |
| Zeros (%) | 90.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 21.29 |
| Maximum | 61.1 |
| Range | 61.1 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 9.6310932 |
|---|---|
| Coefficient of variation (CV) | 3.6421057 |
| Kurtosis | 17.718218 |
| Mean | 2.644375 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.1339272 |
| Sum | 423.1 |
| Variance | 92.757956 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) |
| 0 | 145 | |
| 40 | 1 | 0.6% |
| 23 | 1 | 0.6% |
| 61.1 | 1 | 0.6% |
| 21.2 | 1 | 0.6% |
| 36.2 | 1 | 0.6% |
| 52 | 1 | 0.6% |
| 20 | 1 | 0.6% |
| 50 | 1 | 0.6% |
| 17.5 | 1 | 0.6% |
| Other values (6) | 6 | 3.8% |
| Value | Count | Frequency (%) |
| 0 | 145 | |
| 1.4 | 1 | 0.6% |
| 10 | 1 | 0.6% |
| 15.4 | 1 | 0.6% |
| 16.7 | 1 | 0.6% |
| 17.5 | 1 | 0.6% |
| 20 | 1 | 0.6% |
| 21.2 | 1 | 0.6% |
| 23 | 1 | 0.6% |
| 29.2 | 1 | 0.6% |
| Value | Count | Frequency (%) |
| 61.1 | 1 | |
| 52 | 1 | |
| 50 | 1 | |
| 40 | 1 | |
| 36.2 | 1 | |
| 29.4 | 1 | |
| 29.2 | 1 | |
| 23 | 1 | |
| 21.2 | 1 | |
| 20 | 1 |
| District Code | All Grades | Total Students | AfriAmerican-Black-% | Secondary | High | Tests Taken | % Score 1-2 | % Score 3-5 | Primary | |
|---|---|---|---|---|---|---|---|---|---|---|
| District Code | 1.000 | -0.205 | -0.295 | -0.016 | -0.160 | -0.184 | -0.074 | 0.012 | -0.053 | 0.000 |
| All Grades | -0.205 | 1.000 | 0.644 | 0.687 | 0.412 | 0.916 | 0.523 | 0.400 | 0.377 | 0.694 |
| Total Students | -0.295 | 0.644 | 1.000 | -0.008 | 0.084 | 0.672 | 0.634 | 0.456 | 0.447 | 0.694 |
| AfriAmerican-Black-% | -0.016 | 0.687 | -0.008 | 1.000 | 0.428 | 0.560 | 0.137 | 0.103 | 0.058 | 0.181 |
| Secondary | -0.160 | 0.412 | 0.084 | 0.428 | 1.000 | 0.108 | 0.093 | 0.093 | 0.138 | 0.694 |
| High | -0.184 | 0.916 | 0.672 | 0.560 | 0.108 | 1.000 | 0.556 | 0.405 | 0.380 | 0.694 |
| Tests Taken | -0.074 | 0.523 | 0.634 | 0.137 | 0.093 | 0.556 | 1.000 | 0.573 | 0.511 | 0.694 |
| % Score 1-2 | 0.012 | 0.400 | 0.456 | 0.103 | 0.093 | 0.405 | 0.573 | 1.000 | 0.845 | 0.074 |
| % Score 3-5 | -0.053 | 0.377 | 0.447 | 0.058 | 0.138 | 0.380 | 0.511 | 0.845 | 1.000 | 0.276 |
| Primary | 0.000 | 0.694 | 0.694 | 0.181 | 0.694 | 0.694 | 0.694 | 0.074 | 0.276 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| District Name_x | District Code | All Grades | Total Students | AfriAmerican-Black-% | Primary | Secondary | High | District Name_y | Tests Taken | % Score 1-2 | % Score 3-5 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Abington | 10000 | 1.0 | 111.0 | 0.900901 | 0.0 | 0.0 | 1.0 | Abington | 1.0 | 0.0 | 0.0 |
| 1 | Academy Of the Pacific Rim Charter Public (District) | 4120000 | 14.0 | 307.0 | 4.560261 | 0.0 | 0.0 | 14.0 | Academy Of the Pacific Rim Charter Public (District) | 7.0 | 0.0 | 0.0 |
| 2 | Advanced Math and Science Academy Charter (District) | 4300000 | 10.0 | 21.0 | 47.619048 | 0.0 | 3.0 | 7.0 | Advanced Math and Science Academy Charter (District) | 3.0 | 0.0 | 0.0 |
| 3 | Amherst-Pelham | 6050000 | 29.0 | 108.0 | 26.851852 | 0.0 | 0.0 | 29.0 | Amherst-Pelham | 2.0 | 0.0 | 0.0 |
| 4 | Andover | 90000 | 9.0 | 139.0 | 6.474820 | 0.0 | 0.0 | 9.0 | Andover | 2.0 | 0.0 | 0.0 |
| 5 | Arlington | 100000 | 7.0 | 204.0 | 3.431373 | 0.0 | 0.0 | 7.0 | Arlington | 5.0 | 0.0 | 0.0 |
| 6 | Ashland | 140000 | 2.0 | 80.0 | 2.500000 | 0.0 | 0.0 | 2.0 | Ashland | 8.0 | 0.0 | 0.0 |
| 7 | Assabet Valley Regional Vocational Technical | 8010000 | 0.0 | 21.0 | 0.000000 | 0.0 | 0.0 | 0.0 | Assabet Valley Regional Vocational Technical | 1.0 | 0.0 | 0.0 |
| 8 | Atlantis Charter (District) | 4910000 | 4.0 | 78.0 | 5.128205 | 0.0 | 0.0 | 4.0 | Atlantis Charter (District) | 2.0 | 0.0 | 0.0 |
| 9 | Attleboro | 160000 | 4.0 | 474.0 | 0.843882 | 0.0 | 0.0 | 4.0 | Attleboro | 4.0 | 0.0 | 0.0 |
| District Name_x | District Code | All Grades | Total Students | AfriAmerican-Black-% | Primary | Secondary | High | District Name_y | Tests Taken | % Score 1-2 | % Score 3-5 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 150 | West Bridgewater | 3230000 | 6.0 | 97.0 | 6.185567 | 0.0 | 0.0 | 6.0 | West Bridgewater | 2.0 | 0.0 | 0.0 |
| 151 | West Springfield | 3320000 | 16.0 | 157.0 | 10.191083 | 0.0 | 13.0 | 3.0 | West Springfield | 1.0 | 0.0 | 0.0 |
| 152 | Westfield | 3250000 | 7.0 | 104.0 | 6.730769 | 0.0 | 6.0 | 1.0 | Westfield | 1.0 | 0.0 | 0.0 |
| 153 | Westwood | 3350000 | 1.0 | 58.0 | 1.724138 | 0.0 | 0.0 | 1.0 | Westwood | 1.0 | 0.0 | 0.0 |
| 154 | Weymouth | 3360000 | 8.0 | 458.0 | 1.746725 | 0.0 | 0.0 | 8.0 | Weymouth | 3.0 | 0.0 | 0.0 |
| 155 | Whitman-Hanson | 7800000 | 6.0 | 136.0 | 4.411765 | 0.0 | 0.0 | 6.0 | Whitman-Hanson | 1.0 | 0.0 | 0.0 |
| 156 | Whittier Regional Vocational Technical | 8850000 | 0.0 | 39.0 | 0.000000 | 0.0 | 0.0 | 0.0 | Whittier Regional Vocational Technical | 1.0 | 0.0 | 0.0 |
| 157 | Woburn | 3470000 | 31.0 | 320.0 | 9.687500 | 0.0 | 29.0 | 2.0 | Woburn | 4.0 | 0.0 | 0.0 |
| 158 | Worcester | 3480000 | 69.0 | 3841.0 | 1.796407 | 0.0 | 0.0 | 69.0 | Worcester | 72.0 | 70.8 | 29.2 |
| 159 | State Totals | 0 | 2843.0 | 82946.0 | 3.427531 | 33.0 | 527.0 | 2283.0 | State Totals | 1140.0 | 70.6 | 29.4 |